-- @owner: @zou_jialiang050
-- @date: 2022/09/15
-- @testpoint: show create function修改sql_mode查看显示正确性

--step1:创建表及函数;expect:成功
drop table if exists t_show_create_function_0006;
create table t_show_create_function_0006(c1 int,c2 int,c3 int);
drop function if exists f_show_create_function_0006;
create or replace function f_show_create_function_0006() returns trigger as
$$
declare
begin
    insert into t_show_create_function_0006 values(new.id1, new.id2, new.id3);
    return new;
end
$$ language plpgsql;
/

--step2:show create function修改sql_mode查看显示正确性;expect:成功
show create function f_show_create_function_0006;
set dolphin.sql_mode='sql_mode_strict';
show create function f_show_create_function_0006;

--step3:清理环境;expect:成功
drop function if exists f_show_create_function_0006;
drop table if exists t_show_create_function_0006;
reset dolphin.sql_mode;
